🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-30 🟢

🔹 MYOB Data Extraction & Analysis for Wine Barrel Purchases
👤 Client: 🇦🇺 Australia Member since 2011-07-03
💰 Price: ****
🚩 Problem: Extract and analyze historical MYOB data to identify and quantify oak barrel purchases.
📦 Existing: [MYOB Account], [Excel]

Specifications:

[Target] Extract and categorize MYOB invoices from the past 8 years to identify oak barrel purchases.
[Method] Develop a script or manual process for filtering and extracting relevant data.
[UI/UX] Not specified
[Stack] Python (Pandas), Excel VBA, Google Sheets
[Security] Ensure data privacy and security during extraction and analysis.
[Format] Deliver an Excel summary with yearly spend and number of barrels. Include supporting data and graphs.

Workflow:

Access MYOB account to export relevant invoices over the past 8 years.
Develop a script or manual process to filter out non-barrel purchases from the exported data.
Calculate total spend per year and total number of barrels purchased each year.
Review and interpret invoices for accuracy, especially those with mixed items.
Create an Excel summary document showing yearly spend and number of barrels.
Generate supporting data and graphs to visualize trends over the years.
Upload all deliverables (Excel file, Google sheet) to a shared location.